﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'PRC_TB_USER_TASK_COMMENT_SE')
	BEGIN
		DROP  Procedure  dbo.PRC_TB_USER_TASK_COMMENT_SE
	END

GO

CREATE Procedure dbo.PRC_TB_USER_TASK_COMMENT_SE
(
	@TUTC_TASK_ID int,
	@TUTC_USER_ID int
)
AS

select 
	TUTC_ID,
	TUTC_TASK_ID,
	TUTC_COMMENT
from TB_USER_TASK_COMMENT
where TUTC_TASK_ID = @TUTC_TASK_ID
and TUTC_USER_ID = @TUTC_USER_ID

GO

GRANT EXEC ON dbo.PRC_TB_USER_TASK_COMMENT_SE TO PUBLIC

GO

